When using UR in application A1 on selecting multiple rows, there will be an IN ( intent none) table lock on the accessed table. 在应用程序A1中使用UR来选择多行时,所访问的表中将有一个IN(intentnone)表锁定。
When using CS in application A1, there will be an IS ( intent share) table lock. 在应用程序A1中使用CS时,将有一个IS(intentshare)表锁定。
The one of interest here is the intent share ( IS) lock held by the NEWSTAFF table. 这里有趣的是NEWSTAFF表持有的意图共享(intentshare,IS)锁。
Intent Locks: Used to establish a lock hierarchy. 意向锁:用于建立锁的层次结构。
Intent share locks on all clustered index pages containing those rows, unless the page is already protected by an IX lock. 包含那些行的所有聚集索引页上的意向共享锁,除非页已被ix锁保护。